Pandas Profiling Report

Dataset statistics

Number of variables	32
Number of observations	141947
Missing cells	154010
Missing cells (%)	3.4%
Duplicate rows	10164
Duplicate rows (%)	7.2%
Total size in memory	34.7 MiB
Average record size in memory	256.0 B

Variable types

Categorical	18
Numeric	14

Alerts

Dataset has 10164 (7.2%) duplicate rows	Duplicates
`country` has a high cardinality: 177 distinct values	High cardinality
`reservation_status_date` has a high cardinality: 925 distinct values	High cardinality
`arrival_date_week_number` is highly overall correlated with `arrival_date_month`	High correlation
`agent` is highly overall correlated with `hotel`	High correlation
`company` is highly overall correlated with `hotel`	High correlation
`hotel` is highly overall correlated with `agent` and 1 other fields	High correlation
`is_canceled` is highly overall correlated with `reservation_status`	High correlation
`arrival_date_month` is highly overall correlated with `arrival_date_week_number`	High correlation
`market_segment` is highly overall correlated with `distribution_channel`	High correlation
`distribution_channel` is highly overall correlated with `market_segment`	High correlation
`reserved_room_type` is highly overall correlated with `assigned_room_type`	High correlation
`assigned_room_type` is highly overall correlated with `reserved_room_type`	High correlation
`reservation_status` is highly overall correlated with `is_canceled`	High correlation
`children` is highly imbalanced (81.6%)	Imbalance
`babies` is highly imbalanced (97.1%)	Imbalance
`meal` is highly imbalanced (53.5%)	Imbalance
`country` is highly imbalanced (54.9%)	Imbalance
`distribution_channel` is highly imbalanced (62.9%)	Imbalance
`is_repeated_guest` is highly imbalanced (79.9%)	Imbalance
`reserved_room_type` is highly imbalanced (59.4%)	Imbalance
`assigned_room_type` is highly imbalanced (51.7%)	Imbalance
`deposit_type` is highly imbalanced (64.1%)	Imbalance
`required_car_parking_spaces` is highly imbalanced (85.5%)	Imbalance
`agent` has 19555 (13.8%) missing values	Missing
`company` has 133822 (94.3%) missing values	Missing
`adults` is highly skewed (γ1 = 24.26609101)	Skewed
`previous_cancellations` is highly skewed (γ1 = 20.2286875)	Skewed
`previous_bookings_not_canceled` is highly skewed (γ1 = 25.29075503)	Skewed
`lead_time` has 7861 (5.5%) zeros	Zeros
`stays_in_weekend_nights` has 62065 (43.7%) zeros	Zeros
`stays_in_week_nights` has 8881 (6.3%) zeros	Zeros
`previous_cancellations` has 131027 (92.3%) zeros	Zeros
`previous_bookings_not_canceled` has 138008 (97.2%) zeros	Zeros
`booking_changes` has 120861 (85.1%) zeros	Zeros
`days_in_waiting_list` has 137500 (96.9%) zeros	Zeros
`adr` has 2555 (1.8%) zeros	Zeros
`total_of_special_requests` has 86024 (60.6%) zeros	Zeros

Reproduction

Analysis started	2023-04-12 02:48:14.911418
Analysis finished	2023-04-12 02:50:50.918432
Duration	2 minutes and 36.01 seconds
Software version	ydata-profiling vv4.1.2
Download configuration	config.json

hotel
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

City Hotel	93103
Resort Hotel	48844

Length

Max length	12
Median length	10
Mean length	10.688201
Min length	10

Characters and Unicode

Total characters	1517158
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Resort Hotel
2nd row	Resort Hotel
3rd row	Resort Hotel
4th row	Resort Hotel
5th row	Resort Hotel

Common Values

Value	Count	Frequency (%)
City Hotel	93103	65.6%
Resort Hotel	48844	34.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
hotel	141947	50.0%
city	93103	32.8%
resort	48844	17.2%

Most occurring characters

Value	Count	Frequency (%)
t	283894	18.7%
o	190791	12.6%
e	190791	12.6%
	141947	9.4%
H	141947	9.4%
l	141947	9.4%
C	93103	6.1%
i	93103	6.1%
y	93103	6.1%
R	48844	3.2%
Other values (2)	97688	6.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1091317	71.9%
Uppercase Letter	283894	18.7%
Space Separator	141947	9.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	283894	26.0%
o	190791	17.5%
e	190791	17.5%
l	141947	13.0%
i	93103	8.5%
y	93103	8.5%
s	48844	4.5%
r	48844	4.5%

Uppercase Letter

Value	Count	Frequency (%)
H	141947	50.0%
C	93103	32.8%
R	48844	17.2%

Space Separator

Value	Count	Frequency (%)
	141947	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1375211	90.6%
Common	141947	9.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	283894	20.6%
o	190791	13.9%
e	190791	13.9%
H	141947	10.3%
l	141947	10.3%
C	93103	6.8%
i	93103	6.8%
y	93103	6.8%
R	48844	3.6%
s	48844	3.6%

Common

Value	Count	Frequency (%)
	141947	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1517158	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	283894	18.7%
o	190791	12.6%
e	190791	12.6%
	141947	9.4%
H	141947	9.4%
l	141947	9.4%
C	93103	6.1%
i	93103	6.1%
y	93103	6.1%
R	48844	3.2%
Other values (2)	97688	6.4%

is_canceled
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

0	89108
1	52839

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	141947
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
0	89108	62.8%
1	52839	37.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	89108	62.8%
1	52839	37.2%

Most occurring characters

Value	Count	Frequency (%)
0	89108	62.8%
1	52839	37.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	141947	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	89108	62.8%
1	52839	37.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	141947	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	89108	62.8%
1	52839	37.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	141947	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	89108	62.8%
1	52839	37.2%

lead_time
Real number (ℝ)

Distinct	479
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	102.8211

Minimum	0
Maximum	737
Zeros	7861
Zeros (%)	5.5%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	17
median	68
Q3	158
95-th percentile	320
Maximum	737
Range	737
Interquartile range (IQR)	141

Descriptive statistics

Standard deviation	106.47857
Coefficient of variation (CV)	1.0355712
Kurtosis	1.483849
Mean	102.8211
Median Absolute Deviation (MAD)	59
Skewness	1.3180998
Sum	14595147
Variance	11337.686
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7861	5.5%
1	4153	2.9%
2	2453	1.7%
3	2193	1.5%
4	2033	1.4%
5	1926	1.4%
6	1756	1.2%
7	1553	1.1%
8	1376	1.0%
12	1358	1.0%
Other values (469)	115285	81.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7861	5.5%
1	4153	2.9%
2	2453	1.7%
3	2193	1.5%
4	2033	1.4%
5	1926	1.4%
6	1756	1.2%
7	1553	1.1%
8	1376	1.0%
9	1146	0.8%

Value	Count	Frequency (%)
737	2	< 0.1%
709	1	< 0.1%
629	17	< 0.1%
626	30	< 0.1%
622	17	< 0.1%
615	17	< 0.1%
608	17	< 0.1%
605	30	< 0.1%
601	17	< 0.1%
594	17	< 0.1%

arrival_date_year
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

2019	79264
2020	40687
2018	21996

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	567788
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2018
2nd row	2018
3rd row	2018
4th row	2018
5th row	2018

Common Values

Value	Count	Frequency (%)
2019	79264	55.8%
2020	40687	28.7%
2018	21996	15.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2019	79264	55.8%
2020	40687	28.7%
2018	21996	15.5%

Most occurring characters

Value	Count	Frequency (%)
2	182634	32.2%
0	182634	32.2%
1	101260	17.8%
9	79264	14.0%
8	21996	3.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	567788	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	182634	32.2%
0	182634	32.2%
1	101260	17.8%
9	79264	14.0%
8	21996	3.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	567788	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	182634	32.2%
0	182634	32.2%
1	101260	17.8%
9	79264	14.0%
8	21996	3.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	567788	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	182634	32.2%
0	182634	32.2%
1	101260	17.8%
9	79264	14.0%
8	21996	3.9%

arrival_date_month
Categorical

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

August	17772
October	16127
September	15630
July	15446
May	11791
Other values (7)	65181

Length

Max length	9
Median length	7
Mean length	6.1032146
Min length	3

Characters and Unicode

Total characters	866333
Distinct characters	26
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	July
2nd row	July
3rd row	July
4th row	July
5th row	July

Common Values

Value	Count	Frequency (%)
August	17772	12.5%
October	16127	11.4%
September	15630	11.0%
July	15446	10.9%
May	11791	8.3%
April	11089	7.8%
June	10939	7.7%
December	9812	6.9%
March	9810	6.9%
November	9149	6.4%
Other values (2)	14382	10.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
august	17772	12.5%
october	16127	11.4%
september	15630	11.0%
july	15446	10.9%
may	11791	8.3%
april	11089	7.8%
june	10939	7.7%
december	9812	6.9%
march	9810	6.9%
november	9149	6.4%
Other values (2)	14382	10.1%

Most occurring characters

Value	Count	Frequency (%)
e	130062	15.0%
r	94371	10.9%
u	76311	8.8%
b	59090	6.8%
t	49529	5.7%
a	41993	4.8%
y	41619	4.8%
c	35749	4.1%
m	34591	4.0%
J	32395	3.7%
Other values (16)	270623	31.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	724386	83.6%
Uppercase Letter	141947	16.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	130062	18.0%
r	94371	13.0%
u	76311	10.5%
b	59090	8.2%
t	49529	6.8%
a	41993	5.8%
y	41619	5.7%
c	35749	4.9%
m	34591	4.8%
p	26719	3.7%
Other values (8)	134352	18.5%

Uppercase Letter

Value	Count	Frequency (%)
J	32395	22.8%
A	28861	20.3%
M	21601	15.2%
O	16127	11.4%
S	15630	11.0%
D	9812	6.9%
N	9149	6.4%
F	8372	5.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	866333	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	130062	15.0%
r	94371	10.9%
u	76311	8.8%
b	59090	6.8%
t	49529	5.7%
a	41993	4.8%
y	41619	4.8%
c	35749	4.1%
m	34591	4.0%
J	32395	3.7%
Other values (16)	270623	31.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	866333	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	130062	15.0%
r	94371	10.9%
u	76311	8.8%
b	59090	6.8%
t	49529	5.7%
a	41993	4.8%
y	41619	4.8%
c	35749	4.1%
m	34591	4.0%
J	32395	3.7%
Other values (16)	270623	31.2%

arrival_date_week_number
Real number (ℝ)

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	29.061058

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	18
median	30
Q3	40
95-th percentile	50
Maximum	53
Range	52
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	13.604758
Coefficient of variation (CV)	0.46814392
Kurtosis	-0.94553904
Mean	29.061058
Median Absolute Deviation (MAD)	11
Skewness	-0.20504069
Sum	4125130
Variance	185.08943
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
33	4750	3.3%
41	4102	2.9%
38	4033	2.8%
42	3979	2.8%
32	3898	2.7%
39	3886	2.7%
30	3857	2.7%
34	3811	2.7%
29	3461	2.4%
40	3427	2.4%
Other values (43)	102743	72.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1059	0.7%
2	1251	0.9%
3	1330	0.9%
4	1498	1.1%
5	1400	1.0%
6	1562	1.1%
7	2250	1.6%
8	2244	1.6%
9	2190	1.5%
10	2174	1.5%

Value	Count	Frequency (%)
53	2636	1.9%
52	1708	1.2%
51	1249	0.9%
50	2117	1.5%
49	2629	1.9%
48	2121	1.5%
47	2371	1.7%
46	1999	1.4%
45	2492	1.8%
44	3139	2.2%

arrival_date_day_of_month
Real number (ℝ)

Distinct	30
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.74897

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	30
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.7373137
Coefficient of variation (CV)	0.55478637
Kurtosis	-1.1937217
Mean	15.74897
Median Absolute Deviation (MAD)	8
Skewness	-0.0050601603
Sum	2235519
Variance	76.340651
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
28	8663	6.1%
5	5506	3.9%
17	5343	3.8%
25	5049	3.6%
18	4931	3.5%
15	4931	3.5%
9	4926	3.5%
16	4924	3.5%
12	4894	3.4%
26	4825	3.4%
Other values (20)	87955	62.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	4216	3.0%
2	4686	3.3%
3	4622	3.3%
4	4487	3.2%
5	5506	3.9%
6	4512	3.2%
7	4319	3.0%
8	4727	3.3%
9	4926	3.5%
10	4358	3.1%

Value	Count	Frequency (%)
31	2738	1.9%
30	4690	3.3%
28	8663	6.1%
27	4473	3.2%
26	4825	3.4%
25	5049	3.6%
24	4751	3.3%
23	4360	3.1%
22	4170	2.9%
21	4410	3.1%

stays_in_weekend_nights
Real number (ℝ)

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.92755747

Minimum	0
Maximum	19
Zeros	62065
Zeros (%)	43.7%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	2
Maximum	19
Range	19
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.0008171
Coefficient of variation (CV)	1.0789813
Kurtosis	7.2352028
Mean	0.92755747
Median Absolute Deviation (MAD)	1
Skewness	1.3822691
Sum	131664
Variance	1.0016349
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0	62065	43.7%
2	39780	28.0%
1	35967	25.3%
4	2212	1.6%
3	1514	1.1%
6	167	0.1%
5	100	0.1%
8	71	0.1%
7	31	< 0.1%
9	15	< 0.1%
Other values (7)	25	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	62065	43.7%
1	35967	25.3%
2	39780	28.0%
3	1514	1.1%
4	2212	1.6%
5	100	0.1%
6	167	0.1%
7	31	< 0.1%
8	71	0.1%
9	15	< 0.1%

Value	Count	Frequency (%)
19	1	< 0.1%
18	2	< 0.1%
16	3	< 0.1%
14	2	< 0.1%
13	4	< 0.1%
12	6	< 0.1%
10	7	< 0.1%
9	15	< 0.1%
8	71	0.1%
7	31	< 0.1%

stays_in_week_nights
Real number (ℝ)

Distinct	35
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.4955089

Minimum	0
Maximum	50
Zeros	8881
Zeros (%)	6.3%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	3
95-th percentile	5
Maximum	50
Range	50
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.9097836
Coefficient of variation (CV)	0.76528825
Kurtosis	24.026218
Mean	2.4955089
Median Absolute Deviation (MAD)	1
Skewness	2.8594249
Sum	354230
Variance	3.6472735
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=35)

Value	Count	Frequency (%)
2	40810	28.8%
1	36419	25.7%
3	25612	18.0%
5	13113	9.2%
4	11209	7.9%
0	8881	6.3%
6	1857	1.3%
10	1252	0.9%
7	1248	0.9%
8	789	0.6%
Other values (25)	757	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8881	6.3%
1	36419	25.7%
2	40810	28.8%
3	25612	18.0%
4	11209	7.9%
5	13113	9.2%
6	1857	1.3%
7	1248	0.9%
8	789	0.6%
9	279	0.2%

Value	Count	Frequency (%)
50	1	< 0.1%
42	2	< 0.1%
41	1	< 0.1%
40	2	< 0.1%
35	1	< 0.1%
34	1	< 0.1%
33	2	< 0.1%
32	1	< 0.1%
30	6	< 0.1%
26	1	< 0.1%

adults
Real number (ℝ)

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.8525506

Minimum	0
Maximum	55
Zeros	448
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	2
Maximum	55
Range	55
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.6285531
Coefficient of variation (CV)	0.33929065
Kurtosis	1640.728
Mean	1.8525506
Median Absolute Deviation (MAD)	0
Skewness	24.266091
Sum	262964
Variance	0.395079
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
2	107169	75.5%
1	27564	19.4%
3	6664	4.7%
0	448	0.3%
4	70	< 0.1%
26	10	< 0.1%
27	4	< 0.1%
20	4	< 0.1%
5	4	< 0.1%
40	2	< 0.1%
Other values (4)	8	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	448	0.3%
1	27564	19.4%
2	107169	75.5%
3	6664	4.7%
4	70	< 0.1%
5	4	< 0.1%
6	2	< 0.1%
10	2	< 0.1%
20	4	< 0.1%
26	10	< 0.1%

Value	Count	Frequency (%)
55	2	< 0.1%
50	2	< 0.1%
40	2	< 0.1%
27	4	< 0.1%
26	10	< 0.1%
20	4	< 0.1%
10	2	< 0.1%
6	2	< 0.1%
5	4	< 0.1%
4	70	< 0.1%

children
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	8
Missing (%)	< 0.1%
Memory size	1.1 MiB

0.0	132400
1.0	5358
2.0	4097
3.0	81
10.0	3

Length

Max length	4
Median length	3
Mean length	3.0000211
Min length	3

Characters and Unicode

Total characters	425820
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	132400	93.3%
1.0	5358	3.8%
2.0	4097	2.9%
3.0	81	0.1%
10.0	3	< 0.1%
(Missing)	8	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	132400	93.3%
1.0	5358	3.8%
2.0	4097	2.9%
3.0	81	0.1%
10.0	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	274342	64.4%
.	141939	33.3%
1	5361	1.3%
2	4097	1.0%
3	81	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	283881	66.7%
Other Punctuation	141939	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	274342	96.6%
1	5361	1.9%
2	4097	1.4%
3	81	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
.	141939	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	425820	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	274342	64.4%
.	141939	33.3%
1	5361	1.3%
2	4097	1.0%
3	81	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	425820	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	274342	64.4%
.	141939	33.3%
1	5361	1.3%
2	4097	1.0%
3	81	< 0.1%

babies
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

0	140813
1	1114
2	17
9	2
10	1

Length

Max length	2
Median length	1
Mean length	1.000007
Min length	1

Characters and Unicode

Total characters	141948
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	140813	99.2%
1	1114	0.8%
2	17	< 0.1%
9	2	< 0.1%
10	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	140813	99.2%
1	1114	0.8%
2	17	< 0.1%
9	2	< 0.1%
10	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	140814	99.2%
1	1115	0.8%
2	17	< 0.1%
9	2	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	141948	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	140814	99.2%
1	1115	0.8%
2	17	< 0.1%
9	2	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	141948	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	140814	99.2%
1	1115	0.8%
2	17	< 0.1%
9	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	141948	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	140814	99.2%
1	1115	0.8%
2	17	< 0.1%
9	2	< 0.1%

meal
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

BB	109878
HB	18402
SC	11067
Undefined	1372
FB	1228

Length

Max length	9
Median length	2
Mean length	2.0676591
Min length	2

Characters and Unicode

Total characters	293498
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	BB
2nd row	HB
3rd row	BB
4th row	BB
5th row	BB

Common Values

Value	Count	Frequency (%)
BB	109878	77.4%
HB	18402	13.0%
SC	11067	7.8%
Undefined	1372	1.0%
FB	1228	0.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
bb	109878	77.4%
hb	18402	13.0%
sc	11067	7.8%
undefined	1372	1.0%
fb	1228	0.9%

Most occurring characters

Value	Count	Frequency (%)
B	239386	81.6%
H	18402	6.3%
S	11067	3.8%
C	11067	3.8%
n	2744	0.9%
d	2744	0.9%
e	2744	0.9%
U	1372	0.5%
f	1372	0.5%
i	1372	0.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	282522	96.3%
Lowercase Letter	10976	3.7%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
B	239386	84.7%
H	18402	6.5%
S	11067	3.9%
C	11067	3.9%
U	1372	0.5%
F	1228	0.4%

Lowercase Letter

Value	Count	Frequency (%)
n	2744	25.0%
d	2744	25.0%
e	2744	25.0%
f	1372	12.5%
i	1372	12.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	293498	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
B	239386	81.6%
H	18402	6.3%
S	11067	3.8%
C	11067	3.8%
n	2744	0.9%
d	2744	0.9%
e	2744	0.9%
U	1372	0.5%
f	1372	0.5%
i	1372	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	293498	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
B	239386	81.6%
H	18402	6.3%
S	11067	3.8%
C	11067	3.8%
n	2744	0.9%
d	2744	0.9%
e	2744	0.9%
U	1372	0.5%
f	1372	0.5%
i	1372	0.5%

country
Categorical

HIGH CARDINALITY IMBALANCE

Distinct	177
Distinct (%)	0.1%
Missing	625
Missing (%)	0.4%
Memory size	1.1 MiB

PRT	62384
GBR	13487
FRA	11792
ESP	10519
DEU	7813
Other values (172)	35327

Length

Max length	3
Median length	3
Mean length	2.9900086
Min length	2

Characters and Unicode

Total characters	422554
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	26 ?
Unique (%)	< 0.1%

Sample

1st row	PRT
2nd row	PRT
3rd row	PRT
4th row	PRT
5th row	PRT

Common Values

Value	Count	Frequency (%)
PRT	62384	43.9%
GBR	13487	9.5%
FRA	11792	8.3%
ESP	10519	7.4%
DEU	7813	5.5%
ITA	4321	3.0%
IRL	3860	2.7%
BEL	2554	1.8%
BRA	2374	1.7%
NLD	2304	1.6%
Other values (167)	19914	14.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
prt	62384	44.1%
gbr	13487	9.5%
fra	11792	8.3%
esp	10519	7.4%
deu	7813	5.5%
ita	4321	3.1%
irl	3860	2.7%
bel	2554	1.8%
bra	2374	1.7%
nld	2304	1.6%
Other values (167)	19914	14.1%

Most occurring characters

Value	Count	Frequency (%)
R	98468	23.3%
P	74386	17.6%
T	68782	16.3%
E	24565	5.8%
A	24172	5.7%
B	18803	4.4%
S	16484	3.9%
G	14598	3.5%
U	14401	3.4%
F	12379	2.9%
Other values (16)	55516	13.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	422554	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	98468	23.3%
P	74386	17.6%
T	68782	16.3%
E	24565	5.8%
A	24172	5.7%
B	18803	4.4%
S	16484	3.9%
G	14598	3.5%
U	14401	3.4%
F	12379	2.9%
Other values (16)	55516	13.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	422554	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	98468	23.3%
P	74386	17.6%
T	68782	16.3%
E	24565	5.8%
A	24172	5.7%
B	18803	4.4%
S	16484	3.9%
G	14598	3.5%
U	14401	3.4%
F	12379	2.9%
Other values (16)	55516	13.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	422554	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
R	98468	23.3%
P	74386	17.6%
T	68782	16.3%
E	24565	5.8%
A	24172	5.7%
B	18803	4.4%
S	16484	3.9%
G	14598	3.5%
U	14401	3.4%
F	12379	2.9%
Other values (16)	55516	13.1%

market_segment
Categorical

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Online TA	62840
Offline TA/TO	30379
Groups	26115
Direct	14973
Corporate	6486
Other values (3)	1154

Length

Max length	13
Median length	9
Mean length	9.0117438
Min length	6

Characters and Unicode

Total characters	1279190
Distinct characters	26
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Online TA
2nd row	Offline TA/TO
3rd row	Online TA
4th row	Online TA
5th row	Direct

Common Values

Value	Count	Frequency (%)
Online TA	62840	44.3%
Offline TA/TO	30379	21.4%
Groups	26115	18.4%
Direct	14973	10.5%
Corporate	6486	4.6%
Complementary	913	0.6%
Aviation	237	0.2%
Undefined	4	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
online	62840	26.7%
ta	62840	26.7%
offline	30379	12.9%
ta/to	30379	12.9%
groups	26115	11.1%
direct	14973	6.4%
corporate	6486	2.8%
complementary	913	0.4%
aviation	237	0.1%
undefined	4	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
n	157217	12.3%
O	123598	9.7%
T	123598	9.7%
e	116512	9.1%
i	108670	8.5%
l	94132	7.4%
A	93456	7.3%
	93219	7.3%
f	60762	4.8%
r	54973	4.3%
Other values (16)	253053	19.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	766449	59.9%
Uppercase Letter	389143	30.4%
Space Separator	93219	7.3%
Other Punctuation	30379	2.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	157217	20.5%
e	116512	15.2%
i	108670	14.2%
l	94132	12.3%
f	60762	7.9%
r	54973	7.2%
o	40237	5.2%
p	33514	4.4%
s	26115	3.4%
u	26115	3.4%
Other values (7)	48202	6.3%

Uppercase Letter

Value	Count	Frequency (%)
O	123598	31.8%
T	123598	31.8%
A	93456	24.0%
G	26115	6.7%
D	14973	3.8%
C	7399	1.9%
U	4	< 0.1%

Space Separator

Value	Count	Frequency (%)
	93219	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	30379	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1155592	90.3%
Common	123598	9.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	157217	13.6%
O	123598	10.7%
T	123598	10.7%
e	116512	10.1%
i	108670	9.4%
l	94132	8.1%
A	93456	8.1%
f	60762	5.3%
r	54973	4.8%
o	40237	3.5%
Other values (14)	182437	15.8%

Common

Value	Count	Frequency (%)
	93219	75.4%
/	30379	24.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1279190	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	157217	12.3%
O	123598	9.7%
T	123598	9.7%
e	116512	9.1%
i	108670	8.5%
l	94132	7.4%
A	93456	7.3%
	93219	7.3%
f	60762	4.8%
r	54973	4.3%
Other values (16)	253053	19.8%

distribution_channel
Categorical

HIGH CORRELATION IMBALANCE

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

TA/TO	116042
Direct	17534
Corporate	8167
GDS	194
Undefined	10

Length

Max length	9
Median length	5
Mean length	5.3512156
Min length	3

Characters and Unicode

Total characters	759589
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	TA/TO
2nd row	TA/TO
3rd row	TA/TO
4th row	TA/TO
5th row	Direct

Common Values

Value	Count	Frequency (%)
TA/TO	116042	81.8%
Direct	17534	12.4%
Corporate	8167	5.8%
GDS	194	0.1%
Undefined	10	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ta/to	116042	81.8%
direct	17534	12.4%
corporate	8167	5.8%
gds	194	0.1%
undefined	10	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
T	232084	30.6%
/	116042	15.3%
O	116042	15.3%
A	116042	15.3%
r	33868	4.5%
e	25721	3.4%
t	25701	3.4%
D	17728	2.3%
i	17544	2.3%
c	17534	2.3%
Other values (10)	41283	5.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	490461	64.6%
Lowercase Letter	153086	20.2%
Other Punctuation	116042	15.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	33868	22.1%
e	25721	16.8%
t	25701	16.8%
i	17544	11.5%
c	17534	11.5%
o	16334	10.7%
a	8167	5.3%
p	8167	5.3%
n	20	< 0.1%
d	20	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
T	232084	47.3%
O	116042	23.7%
A	116042	23.7%
D	17728	3.6%
C	8167	1.7%
G	194	< 0.1%
S	194	< 0.1%
U	10	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
/	116042	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	643547	84.7%
Common	116042	15.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	232084	36.1%
O	116042	18.0%
A	116042	18.0%
r	33868	5.3%
e	25721	4.0%
t	25701	4.0%
D	17728	2.8%
i	17544	2.7%
c	17534	2.7%
o	16334	2.5%
Other values (9)	24949	3.9%

Common

Value	Count	Frequency (%)
/	116042	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	759589	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
T	232084	30.6%
/	116042	15.3%
O	116042	15.3%
A	116042	15.3%
r	33868	4.5%
e	25721	3.4%
t	25701	3.4%
D	17728	2.3%
i	17544	2.3%
c	17534	2.3%
Other values (10)	41283	5.4%

is_repeated_guest
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

0	137495
1	4452

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	141947
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	137495	96.9%
1	4452	3.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	137495	96.9%
1	4452	3.1%

Most occurring characters

Value	Count	Frequency (%)
0	137495	96.9%
1	4452	3.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	141947	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	137495	96.9%
1	4452	3.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	141947	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	137495	96.9%
1	4452	3.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	141947	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	137495	96.9%
1	4452	3.1%

previous_cancellations
Real number (ℝ)

SKEWED ZEROS

Distinct	15
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.12541301

Minimum	0
Maximum	26
Zeros	131027
Zeros (%)	92.3%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	26
Range	26
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.0596306
Coefficient of variation (CV)	8.4491288
Kurtosis	448.44148
Mean	0.12541301
Median Absolute Deviation (MAD)	0
Skewness	20.228688
Sum	17802
Variance	1.1228171
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
0	131027	92.3%
1	10313	7.3%
2	147	0.1%
24	96	0.1%
3	73	0.1%
26	52	< 0.1%
25	50	< 0.1%
19	38	< 0.1%
11	37	< 0.1%
4	31	< 0.1%
Other values (5)	83	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	131027	92.3%
1	10313	7.3%
2	147	0.1%
3	73	0.1%
4	31	< 0.1%
5	19	< 0.1%
6	22	< 0.1%
11	37	< 0.1%
13	12	< 0.1%
14	28	< 0.1%

Value	Count	Frequency (%)
26	52	< 0.1%
25	50	< 0.1%
24	96	0.1%
21	2	< 0.1%
19	38	< 0.1%
14	28	< 0.1%
13	12	< 0.1%
11	37	< 0.1%
6	22	< 0.1%
5	19	< 0.1%

previous_bookings_not_canceled
Real number (ℝ)

SKEWED ZEROS

Distinct	73
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1203266

Minimum	0
Maximum	72
Zeros	138008
Zeros (%)	97.2%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	72
Range	72
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.381798
Coefficient of variation (CV)	11.483728
Kurtosis	892.0841
Mean	0.1203266
Median Absolute Deviation (MAD)	0
Skewness	25.290755
Sum	17080
Variance	1.9093657
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	138008	97.2%
1	1721	1.2%
2	643	0.5%
3	361	0.3%
4	240	0.2%
5	192	0.1%
6	122	0.1%
7	94	0.1%
8	74	0.1%
9	63	< 0.1%
Other values (63)	429	0.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	138008	97.2%
1	1721	1.2%
2	643	0.5%
3	361	0.3%
4	240	0.2%
5	192	0.1%
6	122	0.1%
7	94	0.1%
8	74	0.1%
9	63	< 0.1%

Value	Count	Frequency (%)
72	1	< 0.1%
71	1	< 0.1%
70	1	< 0.1%
69	1	< 0.1%
68	1	< 0.1%
67	1	< 0.1%
66	1	< 0.1%
65	1	< 0.1%
64	1	< 0.1%
63	1	< 0.1%

reserved_room_type
Categorical

HIGH CORRELATION IMBALANCE

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

A	104124
D	21453
E	7530
F	3279
G	2371
Other values (5)	3190

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	141947
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	A
2nd row	D
3rd row	E
4th row	E
5th row	E

Common Values

Value	Count	Frequency (%)
A	104124	73.4%
D	21453	15.1%
E	7530	5.3%
F	3279	2.3%
G	2371	1.7%
B	1367	1.0%
C	1107	0.8%
H	691	0.5%
P	13	< 0.1%
L	12	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
a	104124	73.4%
d	21453	15.1%
e	7530	5.3%
f	3279	2.3%
g	2371	1.7%
b	1367	1.0%
c	1107	0.8%
h	691	0.5%
p	13	< 0.1%
l	12	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
A	104124	73.4%
D	21453	15.1%
E	7530	5.3%
F	3279	2.3%
G	2371	1.7%
B	1367	1.0%
C	1107	0.8%
H	691	0.5%
P	13	< 0.1%
L	12	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	141947	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	104124	73.4%
D	21453	15.1%
E	7530	5.3%
F	3279	2.3%
G	2371	1.7%
B	1367	1.0%
C	1107	0.8%
H	691	0.5%
P	13	< 0.1%
L	12	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	141947	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	104124	73.4%
D	21453	15.1%
E	7530	5.3%
F	3279	2.3%
G	2371	1.7%
B	1367	1.0%
C	1107	0.8%
H	691	0.5%
P	13	< 0.1%
L	12	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	141947	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	104124	73.4%
D	21453	15.1%
E	7530	5.3%
F	3279	2.3%
G	2371	1.7%
B	1367	1.0%
C	1107	0.8%
H	691	0.5%
P	13	< 0.1%
L	12	< 0.1%

assigned_room_type
Categorical

HIGH CORRELATION IMBALANCE

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

A	88864
D	29427
E	9180
F	4397
G	2955
Other values (7)	7124

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	141947
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	A
2nd row	D
3rd row	E
4th row	E
5th row	E

Common Values

Value	Count	Frequency (%)
A	88864	62.6%
D	29427	20.7%
E	9180	6.5%
F	4397	3.1%
G	2955	2.1%
C	2861	2.0%
B	2684	1.9%
H	847	0.6%
I	409	0.3%
K	308	0.2%
Other values (2)	15	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
a	88864	62.6%
d	29427	20.7%
e	9180	6.5%
f	4397	3.1%
g	2955	2.1%
c	2861	2.0%
b	2684	1.9%
h	847	0.6%
i	409	0.3%
k	308	0.2%
Other values (2)	15	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
A	88864	62.6%
D	29427	20.7%
E	9180	6.5%
F	4397	3.1%
G	2955	2.1%
C	2861	2.0%
B	2684	1.9%
H	847	0.6%
I	409	0.3%
K	308	0.2%
Other values (2)	15	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	141947	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	88864	62.6%
D	29427	20.7%
E	9180	6.5%
F	4397	3.1%
G	2955	2.1%
C	2861	2.0%
B	2684	1.9%
H	847	0.6%
I	409	0.3%
K	308	0.2%
Other values (2)	15	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	141947	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	88864	62.6%
D	29427	20.7%
E	9180	6.5%
F	4397	3.1%
G	2955	2.1%
C	2861	2.0%
B	2684	1.9%
H	847	0.6%
I	409	0.3%
K	308	0.2%
Other values (2)	15	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	141947	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	88864	62.6%
D	29427	20.7%
E	9180	6.5%
F	4397	3.1%
G	2955	2.1%
C	2861	2.0%
B	2684	1.9%
H	847	0.6%
I	409	0.3%
K	308	0.2%
Other values (2)	15	< 0.1%

booking_changes
Real number (ℝ)

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.21393901

Minimum	0
Maximum	21
Zeros	120861
Zeros (%)	85.1%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	21
Range	21
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.63647896
Coefficient of variation (CV)	2.9750487
Kurtosis	85.953003
Mean	0.21393901
Median Absolute Deviation (MAD)	0
Skewness	6.1525617
Sum	30368
Variance	0.40510546
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
0	120861	85.1%
1	15064	10.6%
2	4271	3.0%
3	1044	0.7%
4	415	0.3%
5	136	0.1%
6	64	< 0.1%
7	33	< 0.1%
8	18	< 0.1%
9	8	< 0.1%
Other values (11)	33	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	120861	85.1%
1	15064	10.6%
2	4271	3.0%
3	1044	0.7%
4	415	0.3%
5	136	0.1%
6	64	< 0.1%
7	33	< 0.1%
8	18	< 0.1%
9	8	< 0.1%

Value	Count	Frequency (%)
21	1	< 0.1%
20	2	< 0.1%
18	1	< 0.1%
17	3	< 0.1%
16	2	< 0.1%
15	3	< 0.1%
14	5	< 0.1%
13	5	< 0.1%
12	2	< 0.1%
11	3	< 0.1%

deposit_type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

No Deposit	123396
Non Refund	18385
Refundable	166

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	1419470
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No Deposit
2nd row	No Deposit
3rd row	No Deposit
4th row	No Deposit
5th row	No Deposit

Common Values

Value	Count	Frequency (%)
No Deposit	123396	86.9%
Non Refund	18385	13.0%
Refundable	166	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	123396	43.5%
deposit	123396	43.5%
non	18385	6.5%
refund	18385	6.5%
refundable	166	0.1%

Most occurring characters

Value	Count	Frequency (%)
o	265177	18.7%
e	142113	10.0%
N	141781	10.0%
	141781	10.0%
s	123396	8.7%
i	123396	8.7%
t	123396	8.7%
p	123396	8.7%
D	123396	8.7%
n	36936	2.6%
Other values (7)	74702	5.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	993961	70.0%
Uppercase Letter	283728	20.0%
Space Separator	141781	10.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	265177	26.7%
e	142113	14.3%
s	123396	12.4%
i	123396	12.4%
t	123396	12.4%
p	123396	12.4%
n	36936	3.7%
f	18551	1.9%
u	18551	1.9%
d	18551	1.9%
Other values (3)	498	0.1%

Uppercase Letter

Value	Count	Frequency (%)
N	141781	50.0%
D	123396	43.5%
R	18551	6.5%

Space Separator

Value	Count	Frequency (%)
	141781	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1277689	90.0%
Common	141781	10.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	265177	20.8%
e	142113	11.1%
N	141781	11.1%
s	123396	9.7%
i	123396	9.7%
t	123396	9.7%
p	123396	9.7%
D	123396	9.7%
n	36936	2.9%
R	18551	1.5%
Other values (6)	56151	4.4%

Common

Value	Count	Frequency (%)
	141781	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1419470	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	265177	18.7%
e	142113	10.0%
N	141781	10.0%
	141781	10.0%
s	123396	8.7%
i	123396	8.7%
t	123396	8.7%
p	123396	8.7%
D	123396	8.7%
n	36936	2.6%
Other values (7)	74702	5.3%

agent
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	333
Distinct (%)	0.3%
Missing	19555
Missing (%)	13.8%
Infinite	0
Infinite (%)	0.0%
Mean	85.685854

Minimum	1
Maximum	535
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	9
median	14
Q3	229
95-th percentile	250
Maximum	535
Range	534
Interquartile range (IQR)	220

Descriptive statistics

Standard deviation	109.6286
Coefficient of variation (CV)	1.2794247
Kurtosis	-0.094985221
Mean	85.685854
Median Absolute Deviation (MAD)	13
Skewness	1.071188
Sum	10487263
Variance	12018.429
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	34292	24.2%
240	16686	11.8%
1	11395	8.0%
6	4506	3.2%
14	4021	2.8%
7	3878	2.7%
250	3357	2.4%
241	2052	1.4%
28	1977	1.4%
3	1781	1.3%
Other values (323)	38447	27.1%
(Missing)	19555	13.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	11395	8.0%
2	208	0.1%
3	1781	1.3%
4	86	0.1%
5	492	0.3%
6	4506	3.2%
7	3878	2.7%
8	1765	1.2%
9	34292	24.2%
10	320	0.2%

Value	Count	Frequency (%)
535	3	< 0.1%
531	68	< 0.1%
527	35	< 0.1%
526	10	< 0.1%
510	2	< 0.1%
509	10	< 0.1%
508	6	< 0.1%
502	24	< 0.1%
497	1	< 0.1%
495	57	< 0.1%

company
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	352
Distinct (%)	4.3%
Missing	133822
Missing (%)	94.3%
Infinite	0
Infinite (%)	0.0%
Mean	183.23606

Minimum	6
Maximum	543
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	6
5-th percentile	40
Q1	51
median	174
Q3	269
95-th percentile	418.8
Maximum	543
Range	537
Interquartile range (IQR)	218

Descriptive statistics

Standard deviation	128.92195
Coefficient of variation (CV)	0.70358394
Kurtosis	-0.46230987
Mean	183.23606
Median Absolute Deviation (MAD)	107
Skewness	0.60858559
Sum	1488793
Variance	16620.869
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40	1165	0.8%
223	981	0.7%
45	312	0.2%
281	269	0.2%
67	268	0.2%
153	215	0.2%
174	170	0.1%
154	151	0.1%
219	141	0.1%
405	119	0.1%
Other values (342)	4334	3.1%
(Missing)	133822	94.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6	1	< 0.1%
8	2	< 0.1%
9	55	< 0.1%
10	1	< 0.1%
11	2	< 0.1%
12	17	< 0.1%
14	9	< 0.1%
16	7	< 0.1%
18	1	< 0.1%
20	69	< 0.1%

Value	Count	Frequency (%)
543	2	< 0.1%
541	1	< 0.1%
539	2	< 0.1%
534	2	< 0.1%
531	1	< 0.1%
530	5	< 0.1%
528	2	< 0.1%
525	15	< 0.1%
523	19	< 0.1%
521	7	< 0.1%

days_in_waiting_list
Real number (ℝ)

Distinct	128
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.3055648

Minimum	0
Maximum	391
Zeros	137500
Zeros (%)	96.9%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	391
Range	391
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	16.938253
Coefficient of variation (CV)	7.3466829
Kurtosis	185.29882
Mean	2.3055648
Median Absolute Deviation (MAD)	0
Skewness	11.706837
Sum	327268
Variance	286.90442
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	137500	96.9%
58	328	0.2%
39	227	0.2%
87	160	0.1%
44	141	0.1%
31	127	0.1%
69	125	0.1%
50	110	0.1%
122	109	0.1%
77	101	0.1%
Other values (118)	3019	2.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	137500	96.9%
1	12	< 0.1%
2	5	< 0.1%
3	59	< 0.1%
4	25	< 0.1%
5	8	< 0.1%
6	26	< 0.1%
7	4	< 0.1%
8	7	< 0.1%
9	16	< 0.1%

Value	Count	Frequency (%)
391	45	< 0.1%
379	15	< 0.1%
330	15	< 0.1%
259	10	< 0.1%
236	35	< 0.1%
224	10	< 0.1%
223	61	< 0.1%
215	21	< 0.1%
207	15	< 0.1%
193	1	< 0.1%

customer_type
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Transient	101474
Transient-Party	32954
Contract	6747
Group	772

Length

Max length	15
Median length	9
Mean length	10.323656
Min length	5

Characters and Unicode

Total characters	1465412
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Transient
2nd row	Transient
3rd row	Transient
4th row	Transient
5th row	Transient

Common Values

Value	Count	Frequency (%)
Transient	101474	71.5%
Transient-Party	32954	23.2%
Contract	6747	4.8%
Group	772	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
transient	101474	71.5%
transient-party	32954	23.2%
contract	6747	4.8%
group	772	0.5%

Most occurring characters

Value	Count	Frequency (%)
n	275603	18.8%
t	180876	12.3%
r	174901	11.9%
a	174129	11.9%
T	134428	9.2%
s	134428	9.2%
i	134428	9.2%
e	134428	9.2%
y	32954	2.2%
-	32954	2.2%
Other values (7)	56283	3.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1257557	85.8%
Uppercase Letter	174901	11.9%
Dash Punctuation	32954	2.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	275603	21.9%
t	180876	14.4%
r	174901	13.9%
a	174129	13.8%
s	134428	10.7%
i	134428	10.7%
e	134428	10.7%
y	32954	2.6%
o	7519	0.6%
c	6747	0.5%
Other values (2)	1544	0.1%

Uppercase Letter

Value	Count	Frequency (%)
T	134428	76.9%
P	32954	18.8%
C	6747	3.9%
G	772	0.4%

Dash Punctuation

Value	Count	Frequency (%)
-	32954	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1432458	97.8%
Common	32954	2.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	275603	19.2%
t	180876	12.6%
r	174901	12.2%
a	174129	12.2%
T	134428	9.4%
s	134428	9.4%
i	134428	9.4%
e	134428	9.4%
y	32954	2.3%
P	32954	2.3%
Other values (6)	23329	1.6%

Common

Value	Count	Frequency (%)
-	32954	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1465412	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	275603	18.8%
t	180876	12.3%
r	174901	11.9%
a	174129	11.9%
T	134428	9.2%
s	134428	9.2%
i	134428	9.2%
e	134428	9.2%
y	32954	2.2%
-	32954	2.2%
Other values (7)	56283	3.8%

adr
Real number (ℝ)

Distinct	8879
Distinct (%)	6.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	99.416916

Minimum	-6.38
Maximum	5400
Zeros	2555
Zeros (%)	1.8%
Negative	1
Negative (%)	< 0.1%
Memory size	1.1 MiB

Quantile statistics

Minimum	-6.38
5-th percentile	37.4
Q1	65.75
median	90.95
Q3	123
95-th percentile	190
Maximum	5400
Range	5406.38
Interquartile range (IQR)	57.25

Descriptive statistics

Standard deviation	49.675549
Coefficient of variation (CV)	0.49966898
Kurtosis	914.64899
Mean	99.416916
Median Absolute Deviation (MAD)	27.55
Skewness	9.4554177
Sum	14111933
Variance	2467.6602
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
62	6172	4.3%
75	3252	2.3%
90	3051	2.1%
65	2997	2.1%
0	2555	1.8%
80	2181	1.5%
60	1859	1.3%
100	1856	1.3%
95	1777	1.3%
120	1731	1.2%
Other values (8869)	114516	80.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-6.38	1	< 0.1%
0	2555	1.8%
0.26	1	< 0.1%
0.5	1	< 0.1%
1	15	< 0.1%
1.29	1	< 0.1%
1.48	1	< 0.1%
1.56	2	< 0.1%
1.6	2	< 0.1%
1.8	1	< 0.1%

Value	Count	Frequency (%)
5400	1	< 0.1%
510	1	< 0.1%
508	2	< 0.1%
451.5	1	< 0.1%
450	1	< 0.1%
437	1	< 0.1%
426.25	1	< 0.1%
402	1	< 0.1%
397.38	1	< 0.1%
392	2	< 0.1%

required_car_parking_spaces
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

0	133180
1	8730
2	32
3	3
8	2

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	141947
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	133180	93.8%
1	8730	6.2%
2	32	< 0.1%
3	3	< 0.1%
8	2	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	133180	93.8%
1	8730	6.2%
2	32	< 0.1%
3	3	< 0.1%
8	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	133180	93.8%
1	8730	6.2%
2	32	< 0.1%
3	3	< 0.1%
8	2	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	141947	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	133180	93.8%
1	8730	6.2%
2	32	< 0.1%
3	3	< 0.1%
8	2	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	141947	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	133180	93.8%
1	8730	6.2%
2	32	< 0.1%
3	3	< 0.1%
8	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	141947	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	133180	93.8%
1	8730	6.2%
2	32	< 0.1%
3	3	< 0.1%
8	2	< 0.1%

total_of_special_requests
Real number (ℝ)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.54967699

Minimum	0
Maximum	5
Zeros	86024
Zeros (%)	60.6%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	5
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.7865411
Coefficient of variation (CV)	1.4309151
Kurtosis	1.577907
Mean	0.54967699
Median Absolute Deviation (MAD)	0
Skewness	1.3946317
Sum	78025
Variance	0.6186469
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	86024	60.6%
1	37564	26.5%
2	15066	10.6%
3	2887	2.0%
4	362	0.3%
5	44	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	86024	60.6%
1	37564	26.5%
2	15066	10.6%
3	2887	2.0%
4	362	0.3%
5	44	< 0.1%

Value	Count	Frequency (%)
5	44	< 0.1%
4	362	0.3%
3	2887	2.0%
2	15066	10.6%
1	37564	26.5%
0	86024	60.6%

reservation_status
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Check-Out	89198
Canceled	51279
No-Show	1470

Length

Max length	9
Median length	9
Mean length	8.6180335
Min length	7

Characters and Unicode

Total characters	1223304
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Canceled
2nd row	Canceled
3rd row	Canceled
4th row	Canceled
5th row	Canceled

Common Values

Value	Count	Frequency (%)
Check-Out	89198	62.8%
Canceled	51279	36.1%
No-Show	1470	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
check-out	89198	62.8%
canceled	51279	36.1%
no-show	1470	1.0%

Most occurring characters

Value	Count	Frequency (%)
e	191756	15.7%
C	140477	11.5%
c	140477	11.5%
h	90668	7.4%
-	90668	7.4%
u	89198	7.3%
t	89198	7.3%
O	89198	7.3%
k	89198	7.3%
a	51279	4.2%
Other values (7)	161187	13.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	900021	73.6%
Uppercase Letter	232615	19.0%
Dash Punctuation	90668	7.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	191756	21.3%
c	140477	15.6%
h	90668	10.1%
u	89198	9.9%
t	89198	9.9%
k	89198	9.9%
a	51279	5.7%
n	51279	5.7%
l	51279	5.7%
d	51279	5.7%
Other values (2)	4410	0.5%

Uppercase Letter

Value	Count	Frequency (%)
C	140477	60.4%
O	89198	38.3%
N	1470	0.6%
S	1470	0.6%

Dash Punctuation

Value	Count	Frequency (%)
-	90668	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1132636	92.6%
Common	90668	7.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	191756	16.9%
C	140477	12.4%
c	140477	12.4%
h	90668	8.0%
u	89198	7.9%
t	89198	7.9%
O	89198	7.9%
k	89198	7.9%
a	51279	4.5%
n	51279	4.5%
Other values (6)	109908	9.7%

Common

Value	Count	Frequency (%)
-	90668	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1223304	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	191756	15.7%
C	140477	11.5%
c	140477	11.5%
h	90668	7.4%
-	90668	7.4%
u	89198	7.3%
t	89198	7.3%
O	89198	7.3%
k	89198	7.3%
a	51279	4.2%
Other values (7)	161187	13.2%

reservation_status_date
Categorical

Distinct	925
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

2018-10-21	1461
2019-01-01	951
2019-07-06	931
2019-11-25	842
2018-07-06	805
Other values (920)	136957

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	1419470
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	27 ?
Unique (%)	< 0.1%

Sample

1st row	2018-05-06
2nd row	2018-04-22
3rd row	2018-06-23
4th row	2018-05-11
5th row	2018-05-29

Common Values

Value	Count	Frequency (%)
2018-10-21	1461	1.0%
2019-01-01	951	0.7%
2019-07-06	931	0.7%
2019-11-25	842	0.6%
2018-07-06	805	0.6%
2018-01-01	763	0.5%
2019-01-18	633	0.4%
2019-07-02	597	0.4%
2019-12-07	534	0.4%
2018-07-02	469	0.3%
Other values (915)	133961	94.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2018-10-21	1461	1.0%
2019-01-01	951	0.7%
2019-07-06	931	0.7%
2019-11-25	842	0.6%
2018-07-06	805	0.6%
2018-01-01	763	0.5%
2019-01-18	633	0.4%
2019-07-02	597	0.4%
2019-12-07	534	0.4%
2018-07-02	469	0.3%
Other values (915)	133961	94.4%

Most occurring characters

Value	Count	Frequency (%)
0	356903	25.1%
-	283894	20.0%
2	257810	18.2%
1	228293	16.1%
9	107594	7.6%
8	53318	3.8%
3	30540	2.2%
7	29293	2.1%
6	24754	1.7%
5	23853	1.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1135576	80.0%
Dash Punctuation	283894	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	356903	31.4%
2	257810	22.7%
1	228293	20.1%
9	107594	9.5%
8	53318	4.7%
3	30540	2.7%
7	29293	2.6%
6	24754	2.2%
5	23853	2.1%
4	23218	2.0%

Dash Punctuation

Value	Count	Frequency (%)
-	283894	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1419470	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	356903	25.1%
-	283894	20.0%
2	257810	18.2%
1	228293	16.1%
9	107594	7.6%
8	53318	3.8%
3	30540	2.2%
7	29293	2.1%
6	24754	1.7%
5	23853	1.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1419470	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	356903	25.1%
-	283894	20.0%
2	257810	18.2%
1	228293	16.1%
9	107594	7.6%
8	53318	3.8%
3	30540	2.2%
7	29293	2.1%
6	24754	1.7%
5	23853	1.7%

Auto

Heatmap
Table

	lead_time	arrival_date_week_number	arrival_date_day_of_month	stays_in_weekend_nights	stays_in_week_nights	adults	previous_cancellations	previous_bookings_not_canceled	booking_changes	agent	company	days_in_waiting_list	adr	total_of_special_requests	hotel	is_canceled	arrival_date_year	arrival_date_month	children	babies	meal	market_segment	distribution_channel	is_repeated_guest	reserved_room_type	assigned_room_type	deposit_type	customer_type	required_car_parking_spaces	reservation_status
lead_time	1.000	0.043	0.001	0.156	0.277	0.194	0.235	-0.180	-0.020	-0.152	0.308	0.137	-0.005	-0.091	0.105	0.308	0.099	0.129	0.030	0.010	0.088	0.173	0.116	0.123	0.050	0.066	0.286	0.131	0.058	0.227
arrival_date_week_number	0.043	1.000	0.065	0.006	0.001	-0.014	0.116	-0.039	0.005	-0.058	-0.067	0.017	-0.031	-0.013	0.080	0.070	0.402	0.800	0.059	0.016	0.093	0.088	0.069	0.069	0.044	0.031	0.102	0.125	0.019	0.064
arrival_date_day_of_month	0.001	0.065	1.000	-0.016	-0.014	0.006	-0.020	0.000	0.012	0.003	0.051	0.042	0.034	0.007	0.033	0.022	0.037	0.065	0.013	0.006	0.051	0.040	0.032	0.021	0.012	0.011	0.063	0.040	0.010	0.025
stays_in_weekend_nights	0.156	0.006	-0.016	1.000	0.238	0.130	-0.055	-0.080	0.038	0.133	0.079	-0.076	0.053	0.081	0.201	0.022	0.023	0.046	0.031	0.011	0.058	0.058	0.055	0.082	0.054	0.051	0.074	0.075	0.012	0.022
stays_in_week_nights	0.277	0.001	-0.014	0.238	1.000	0.147	-0.070	-0.115	0.067	0.193	0.259	0.019	0.106	0.091	0.198	0.031	0.011	0.036	0.016	0.000	0.041	0.035	0.007	0.019	0.046	0.047	0.049	0.071	0.015	0.031
adults	0.194	-0.014	0.006	0.130	0.147	1.000	-0.020	-0.202	-0.090	-0.046	0.218	-0.031	0.265	0.161	0.018	0.017	0.008	0.013	0.000	0.000	0.000	0.013	0.012	0.000	0.009	0.007	0.000	0.110	0.000	0.012
previous_cancellations	0.235	0.116	-0.020	-0.055	-0.070	-0.020	1.000	0.068	-0.090	-0.227	-0.155	0.061	-0.170	-0.157	0.062	0.056	0.034	0.036	0.003	0.000	0.101	0.051	0.050	0.169	0.009	0.011	0.064	0.011	0.000	0.040
previous_bookings_not_canceled	-0.180	-0.039	0.000	-0.080	-0.115	-0.202	0.068	1.000	0.031	0.058	-0.270	-0.019	-0.131	0.024	0.016	0.039	0.024	0.018	0.000	0.000	0.013	0.089	0.099	0.300	0.001	0.003	0.013	0.015	0.017	0.028
booking_changes	-0.020	0.005	0.012	0.038	0.067	-0.090	-0.090	0.031	1.000	0.095	0.194	-0.012	0.009	0.045	0.040	0.049	0.015	0.011	0.018	0.014	0.011	0.021	0.028	0.000	0.016	0.057	0.029	0.029	0.018	0.036
agent	-0.152	-0.058	0.003	0.133	0.193	-0.046	-0.227	0.058	0.095	1.000	0.286	-0.004	-0.009	0.069	0.823	0.095	0.093	0.086	0.059	0.027	0.182	0.226	0.204	0.083	0.145	0.135	0.125	0.136	0.133	0.070
company	0.308	-0.067	0.051	0.079	0.259	0.218	-0.155	-0.270	0.194	0.286	1.000	-0.006	0.011	-0.109	0.537	0.110	0.272	0.237	0.043	0.056	0.206	0.387	0.202	0.337	0.096	0.086	0.179	0.248	0.033	0.086
days_in_waiting_list	0.137	0.017	0.042	-0.076	0.019	-0.031	0.061	-0.019	-0.012	-0.004	-0.006	1.000	-0.028	-0.121	0.091	0.049	0.065	0.065	0.018	0.000	0.089	0.075	0.028	0.025	0.027	0.027	0.105	0.081	0.031	0.038
adr	-0.005	-0.031	0.034	0.053	0.106	0.265	-0.170	-0.131	0.009	-0.009	0.011	-0.028	1.000	0.205	0.000	0.000	0.000	0.004	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.006	0.000	0.000	0.000
total_of_special_requests	-0.091	-0.013	0.007	0.081	0.091	0.161	-0.157	0.024	0.045	0.069	-0.109	-0.121	0.205	1.000	0.066	0.258	0.087	0.053	0.065	0.064	0.066	0.221	0.069	0.037	0.082	0.072	0.220	0.118	0.047	0.184
hotel	0.105	0.080	0.033	0.201	0.198	0.018	0.062	0.016	0.040	0.823	0.537	0.091	0.000	0.066	1.000	0.137	0.036	0.085	0.051	0.049	0.305	0.155	0.192	0.032	0.326	0.393	0.178	0.067	0.223	0.139
is_canceled	0.308	0.070	0.022	0.022	0.031	0.017	0.056	0.039	0.049	0.095	0.110	0.049	0.000	0.258	0.137	1.000	0.019	0.073	0.029	0.035	0.057	0.280	0.174	0.063	0.087	0.227	0.497	0.112	0.198	0.999
arrival_date_year	0.099	0.402	0.037	0.023	0.011	0.008	0.034	0.024	0.015	0.093	0.272	0.065	0.000	0.087	0.036	0.019	1.000	0.403	0.042	0.008	0.106	0.142	0.025	0.010	0.077	0.047	0.046	0.167	0.015	0.019
arrival_date_month	0.129	0.800	0.065	0.046	0.036	0.013	0.036	0.018	0.011	0.086	0.237	0.065	0.004	0.053	0.085	0.073	0.403	1.000	0.066	0.019	0.101	0.094	0.075	0.069	0.048	0.029	0.104	0.124	0.020	0.066
children	0.030	0.059	0.013	0.031	0.016	0.000	0.003	0.000	0.018	0.059	0.043	0.018	0.000	0.065	0.051	0.029	0.042	0.066	1.000	0.025	0.032	0.102	0.045	0.032	0.352	0.297	0.073	0.066	0.032	0.038
babies	0.010	0.016	0.006	0.011	0.000	0.000	0.000	0.000	0.014	0.027	0.056	0.000	0.000	0.064	0.049	0.035	0.008	0.019	0.025	1.000	0.014	0.036	0.029	0.009	0.042	0.046	0.024	0.017	0.021	0.024
meal	0.088	0.093	0.051	0.058	0.041	0.000	0.101	0.013	0.011	0.182	0.206	0.089	0.000	0.066	0.305	0.057	0.106	0.101	0.032	0.014	1.000	0.198	0.074	0.061	0.093	0.106	0.094	0.141	0.024	0.047
market_segment	0.173	0.088	0.040	0.058	0.035	0.013	0.051	0.089	0.021	0.226	0.387	0.075	0.000	0.221	0.155	0.280	0.142	0.094	0.102	0.036	0.198	1.000	0.693	0.316	0.142	0.125	0.364	0.285	0.093	0.206
distribution_channel	0.116	0.069	0.032	0.055	0.007	0.012	0.050	0.099	0.028	0.204	0.202	0.028	0.000	0.069	0.192	0.174	0.025	0.075	0.045	0.029	0.074	0.693	1.000	0.268	0.106	0.099	0.090	0.089	0.074	0.129
is_repeated_guest	0.123	0.069	0.021	0.082	0.019	0.000	0.169	0.300	0.000	0.083	0.337	0.025	0.000	0.037	0.032	0.063	0.010	0.069	0.032	0.009	0.061	0.316	0.268	1.000	0.037	0.069	0.055	0.087	0.064	0.064
reserved_room_type	0.050	0.044	0.012	0.054	0.046	0.009	0.009	0.001	0.016	0.145	0.096	0.027	0.000	0.082	0.326	0.087	0.077	0.048	0.352	0.042	0.093	0.142	0.106	0.037	1.000	0.766	0.153	0.122	0.082	0.062
assigned_room_type	0.066	0.031	0.011	0.051	0.047	0.007	0.011	0.003	0.057	0.135	0.086	0.027	0.000	0.072	0.393	0.227	0.047	0.029	0.297	0.046	0.106	0.125	0.099	0.069	0.766	1.000	0.198	0.097	0.096	0.162
deposit_type	0.286	0.102	0.063	0.074	0.049	0.000	0.064	0.013	0.029	0.125	0.179	0.105	0.006	0.220	0.178	0.497	0.046	0.104	0.073	0.024	0.094	0.364	0.090	0.055	0.153	0.198	1.000	0.086	0.072	0.357
customer_type	0.131	0.125	0.040	0.075	0.071	0.110	0.011	0.015	0.029	0.136	0.248	0.081	0.000	0.118	0.067	0.112	0.167	0.124	0.066	0.017	0.141	0.285	0.089	0.087	0.122	0.097	0.086	1.000	0.049	0.079
required_car_parking_spaces	0.058	0.019	0.010	0.012	0.015	0.000	0.000	0.017	0.018	0.133	0.033	0.031	0.000	0.047	0.223	0.198	0.015	0.020	0.032	0.021	0.024	0.093	0.074	0.064	0.082	0.096	0.072	0.049	1.000	0.139
reservation_status	0.227	0.064	0.025	0.022	0.031	0.012	0.040	0.028	0.036	0.070	0.086	0.038	0.000	0.184	0.139	0.999	0.019	0.066	0.038	0.024	0.047	0.206	0.129	0.064	0.062	0.162	0.357	0.079	0.139	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	hotel	is_canceled	lead_time	arrival_date_year	arrival_date_month	arrival_date_week_number	arrival_date_day_of_month	stays_in_weekend_nights	stays_in_week_nights	adults	children	meal	country	market_segment	distribution_channel	reserved_room_type	assigned_room_type	deposit_type	agent	company	customer_type	adr	total_of_special_requests	reservation_status	reservation_status_date
0	Resort Hotel	1	85	2018	July	27	1	0	3	2	0.0	BB	PRT	Online TA	TA/TO	A	A	No Deposit	240.0	NaN	Transient	82.00	1	Canceled	2018-05-06
1	Resort Hotel	1	75	2018	July	27	1	0	3	2	0.0	HB	PRT	Offline TA/TO	TA/TO	D	D	No Deposit	15.0	NaN	Transient	105.50	0	Canceled	2018-04-22
2	Resort Hotel	1	23	2018	July	27	1	0	4	2	0.0	BB	PRT	Online TA	TA/TO	E	E	No Deposit	240.0	NaN	Transient	123.00	0	Canceled	2018-06-23
3	Resort Hotel	1	60	2018	July	27	1	2	5	2	0.0	BB	PRT	Online TA	TA/TO	E	E	No Deposit	240.0	NaN	Transient	107.00	2	Canceled	2018-05-11
4	Resort Hotel	1	96	2018	July	27	1	2	8	2	0.0	BB	PRT	Direct	Direct	E	E	No Deposit	NaN	NaN	Transient	108.30	2	Canceled	2018-05-29
5	Resort Hotel	1	45	2018	July	27	2	1	3	3	0.0	BB	PRT	Online TA	TA/TO	D	D	No Deposit	241.0	NaN	Transient	108.80	1	Canceled	2018-05-19
6	Resort Hotel	1	40	2018	July	27	2	1	3	3	0.0	BB	PRT	Online TA	TA/TO	D	D	No Deposit	241.0	NaN	Transient	108.80	1	Canceled	2018-06-19
7	Resort Hotel	1	43	2018	July	27	2	1	3	3	0.0	BB	PRT	Online TA	TA/TO	D	D	No Deposit	241.0	NaN	Transient	108.80	0	Canceled	2018-05-23
8	Resort Hotel	1	45	2018	July	27	2	2	3	2	0.0	BB	PRT	Online TA	TA/TO	G	G	No Deposit	241.0	NaN	Transient	117.81	0	Canceled	2018-05-18
9	Resort Hotel	1	47	2018	July	27	2	2	5	2	2.0	BB	PRT	Online TA	TA/TO	G	G	No Deposit	240.0	NaN	Transient	153.00	0	Canceled	2018-06-02

	hotel	is_canceled	lead_time	arrival_date_year	arrival_date_month	arrival_date_week_number	arrival_date_day_of_month	stays_in_weekend_nights	stays_in_week_nights	adults	children	meal	country	market_segment	distribution_channel	is_repeated_guest	previous_cancellations	previous_bookings_not_canceled	reserved_room_type	assigned_room_type	booking_changes	deposit_type	agent	company	customer_type	adr	total_of_special_requests	reservation_status	reservation_status_date
141937	City Hotel	1	219	2020	August	35	28	1	3	2	1.0	BB	ROU	Online TA	TA/TO	0	0	0	A	D	1	No Deposit	9.0	NaN	Transient	135.00	2	No-Show	2020-08-28
141938	City Hotel	1	320	2020	August	35	28	2	5	2	0.0	BB	DEU	Online TA	TA/TO	0	0	0	A	A	0	No Deposit	9.0	NaN	Transient	112.76	3	No-Show	2020-08-29
141939	City Hotel	1	1	2020	March	10	7	0	2	2	0.0	SC	PRT	Direct	Direct	1	0	1	A	A	0	No Deposit	NaN	NaN	Transient	98.00	0	No-Show	2020-03-07
141940	City Hotel	1	4	2020	August	35	28	1	0	1	0.0	BB	PRT	Complementary	Corporate	1	0	3	A	A	0	No Deposit	NaN	72.0	Transient	0.00	2	No-Show	2020-08-28
141941	City Hotel	1	2	2020	June	24	11	2	1	1	0.0	BB	PRT	Aviation	Corporate	1	0	2	A	A	0	No Deposit	NaN	153.0	Transient	95.00	0	No-Show	2020-06-11
141942	City Hotel	1	1	2020	February	5	1	0	0	1	0.0	BB	AUT	Aviation	Corporate	1	0	1	A	A	0	No Deposit	NaN	153.0	Transient	0.00	1	No-Show	2020-02-01
141943	City Hotel	1	31	2020	July	29	16	2	0	1	0.0	BB	USA	Direct	Direct	1	0	2	A	A	1	No Deposit	NaN	NaN	Transient	135.00	2	No-Show	2020-07-16
141944	City Hotel	1	25	2020	May	18	6	2	1	1	0.0	BB	FRA	Corporate	Corporate	1	0	1	E	F	0	No Deposit	NaN	450.0	Transient	125.00	0	No-Show	2020-05-06
141945	City Hotel	1	6	2020	July	29	17	1	0	1	0.0	BB	PRT	Corporate	Corporate	1	1	1	A	D	0	No Deposit	NaN	238.0	Transient	65.00	0	No-Show	2020-07-17
141946	City Hotel	1	0	2020	August	31	2	0	2	1	0.0	BB	PRT	Corporate	Corporate	1	0	0	A	C	0	No Deposit	NaN	40.0	Transient	65.00	1	No-Show	2020-08-02

Most frequently occurring

	hotel	is_canceled	lead_time	arrival_date_year	arrival_date_month	arrival_date_week_number	arrival_date_day_of_month	stays_in_weekend_nights	stays_in_week_nights	adults	meal	country	market_segment	distribution_channel	previous_cancellations	reserved_room_type	assigned_room_type	deposit_type	agent	company	days_in_waiting_list	customer_type	adr	reservation_status	reservation_status_date	# duplicates
6589	City Hotel	1	277	2019	November	46	7	1	2	2	BB	PRT	Groups	TA/TO	0	A	A	Non Refund	NaN	NaN	0	Transient	100.0	Canceled	2019-04-04	180
5192	City Hotel	1	68	2019	February	8	17	0	2	2	BB	PRT	Groups	TA/TO	1	A	A	Non Refund	37.0	NaN	0	Transient	75.0	Canceled	2019-01-06	150
6208	City Hotel	1	188	2019	June	25	15	0	2	1	BB	PRT	Offline TA/TO	TA/TO	0	A	A	Non Refund	119.0	NaN	39	Transient	130.0	Canceled	2019-01-18	109
5995	City Hotel	1	158	2019	May	22	24	0	2	1	BB	PRT	Groups	TA/TO	0	A	A	Non Refund	37.0	NaN	31	Transient	130.0	Canceled	2019-01-18	101
4809	City Hotel	1	34	2018	December	50	8	0	2	1	BB	PRT	Offline TA/TO	TA/TO	1	A	A	Non Refund	19.0	NaN	0	Transient	90.0	Canceled	2018-11-17	100
4814	City Hotel	1	34	2019	December	50	8	0	2	1	BB	PRT	Offline TA/TO	TA/TO	1	A	A	Non Refund	19.0	NaN	0	Transient	90.0	Canceled	2019-11-17	100
4739	City Hotel	1	28	2020	March	9	2	0	3	2	BB	PRT	Groups	TA/TO	0	A	A	Non Refund	NaN	NaN	0	Transient	95.0	Canceled	2020-02-02	99
4873	City Hotel	1	38	2020	January	2	14	0	1	1	BB	PRT	Corporate	Corporate	0	A	A	Non Refund	NaN	67.0	0	Transient	75.0	Canceled	2019-12-07	99
5988	City Hotel	1	156	2020	April	17	26	0	3	2	BB	PRT	Groups	TA/TO	0	A	A	Non Refund	37.0	NaN	0	Transient	100.0	Canceled	2019-11-21	99
5221	City Hotel	1	71	2019	June	25	14	0	3	1	BB	PRT	Offline TA/TO	TA/TO	0	A	A	Non Refund	236.0	NaN	0	Transient	120.0	Canceled	2019-04-27	89

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script